How LINQ is beneficial than Stored Procedures?

Question

Anupam Mishra · Answer

How LINQ is beneficial than Stored Procedures?

Anupam Mishra 2739 28-Mar-2016

linq entity framework

Updated on 20-Sep-2020

Anupam Mishra

Other

Follow

Can you answer this question?

Answer

1 Answers

Anupam Mishra

28-Mar-2016

How LINQ is beneficial than Stored Procedures?

There are couple of advantage of LINQ over stored procedures:

1. Debugging - It is really very hard to debug the Stored procedure but as LINQ is part of .NET, we can use visual studio's debugger to debug the queries.

2. Deployment - With stored procedures, we need to provide an additional script for stored procedures but with LINQ everything gets complied into single DLL hence deployment becomes easy.

3. Type Safety - LINQ is type safe, so queries errors are type checked at compile time. It is really good to encounter an error when compiling rather than runtime exception!

interview

How LINQ is beneficial than Stored Procedures?

Anupam Mishra

Can you answer this question?

1 Answers

How LINQ is beneficial than Stored Procedures?

Liked By